Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL
1) Aggregate Functions
2) Analytical Functions
3) Char Functions
4) Constraints
5) Conversion Functions
6) Cursor
7) Data Type
8) Date Timezone
9) Hierarchical Query
10) Index
11) Insert Delete Update
12) Large Objects
13) Numeric Math Functions
14) Object Oriented Database
15) PL SQL
16) Regular Expressions
17) Report Column Page
18) Result Set
19) Select Query
20) Sequence
21) SQL Plus
22) Stored Procedure Function
23) Subquery
24) System Packages
25) System Tables Views
26) Table
27) Table Joins
28) Trigger
29) User Previliege
30) View
31) XML

Result Set
1) A UNION ALL query for a single column
2) A UNION query that uses an ORDER BY clause
3) All locations, where courses are offering, have no departments
4) An MINUS query that uses an ORDER BY clause
5) Combining Data with UNION and subquery
6) Combining Data with UNION for single column
7) Difference between union and union all
8) Eliminate the duplication and mimic a UNION operator by appending the DISTINCT operator
9) INTERSECT
10) Intersect a single column
11) INTERSECT date column
12) Intersect with like operator
13) Loop through result set and output the result set
14) MINUS
15) Minus id column
16) Minus with like operator
17) One result set minus another result set
18) Result set
19) Take the result of the MULTISET UNION DISTINCT operation and pass it as an argument to the SET operator to eliminate duplicates
20) Understanding Intersections and Differences
21) UNION
22) UNION ALL
23) Union all result set
24) Union all with like
25) Union date column
26) Union dba_indexes and dba_tables
27) Union DBA_TABLES and DBA_INDEXES
28) Union result set in action
29) Union two complex queries and subquery
30) Union with like operator
31) Use COUNT to count the rows from a subquery with set operator
32) Use minus and intersect
33) Using union in subquery